A production n8n workflow that pulls decaying posts from GSC (Google Search Console, 谷歌站长工具), drafts a refresh brief, has ChatGPT write the update, validates the new draft, and ships it to the CMS — all in one loop. The full node map, the three prompts, the four validation gates, and the three failure modes that have actually cost me a post.
A 4-signal audit, a 50-page triage, and one Claude formula dragged down a Google Sheet — the boring spreadsheet work produced a 38% revenue lift, not the AI.
A 5-step, sprint-based playbook for refreshing a large content archive with Claude and Google Search Console — built around three measurement gates that keep you out of Helpful Content trouble.